Release 10.1A: OpenEdge Data Management:
SQL Reference

INSERT

Inserts new rows into the specified table or view that will contain either the explicitly specified values or the values returned by the query expression.

Syntax

INSERT INTO [ owner_name.]{table_name|view_name } [ ( column_name [, column_name ] , ... ) ] { VALUES ( value [, value ] , ... ) | query_expression } ;

Examples

INSERT INTO customer (cust_no, name, street, city, state) VALUES (1001, 'RALPH', '#10 Columbia Street', 'New York', 'NY') ; INSERT INTO neworders (order_no, product, qty) SELECT order_no, product, qty FROM orders WHERE order_date = SYSDATE ;

Notes

If the optional list of column names is specified, then only the values for those columns are required. The rest of the columns of the inserted row will contain NULL values, provided that the table definition allows NULL values and there is no DEFAULT clause for the columns. If a DEFAULT clause is specified for a column and the column name is not present in the optional column list, then the column is given the default value.
If the optional list is not specified, then all the column values must be either explicitly specified or returned by the query expression. The order of the values should be the same as the order in which the columns are declared in the declaration of the table or view.
The VALUES ( ... ) form for specifying the column values inserts one row into the table. The query expression form inserts all the rows from the query results.
If the table contains a foreign key and there is no corresponding primary key that matches the values of the foreign key in the record being inserted, the insert operation is rejected.

Authorization

Must have DBA privilege, ownership of the table, INSERT privilege on the table, or SELECT privilege on all the tables or views referred to in the query_expression, if a query_expression is specified.

Related statements

REVOKE